The Merant driver won't extract data type information from arbitrary XML files that have a W3C Schema. The driver can access only documents generated by the XML driver/provider or by the persistence feature that the majority of Merant's 3.7 ODBC drivers support. XML documents you author or generate need to resemble the ones generated by the Merant drivers.
To take advantage of functionality available to string fields (such as sorting, grouping, and conditional formatting), data fields are truncated at 255 characters. This limitation is controlled by a registry setting.
If you want to your data source to read Memo fields without truncating the data, set the following key: HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\DatabaseOptions\ODBC\TreatMemoAsString
.
The Merant driver requires the use of Table and Row Hints. There are examples of how to set up these hints in the section called Table and Row Hint examples. You must work within the parameters of these six possibilities.
Not any XML file can be used to generate reports. Only the following types are supported by the Merant driver:
Data Islands are identified by the <XML>
tag in an XML file. The Data Island can be embedded in the document. Data Islands can include the following schema definition and namespace:
<Schema xmlns="urn:schemas-m icrosoft-c om:xml-d ata" xmlns:dt="urn:schemas-m icrosoft-c om:datatypes">
ADO persisted files are identified by a unique schema namespace URL. Although ADO uses the same data types defined by XML data, the data types use extensions. ADO 2.5 persisted files are identified by the following unique XML element:
<xml xmlns:s="uuid:BDC6E3F0-6 DA3-1 1d1-A 2A3-0 0AA00C14882" xmlns:dt="uuid:C2F41010-6 5B3-1 1d1-A 29F-0 0AA00C14882" xmlns:rs="urn:schemas-m icrosoft-c om:rowset" xmlns:z="#RowsetSchema">
XML files can be specified with a path name or a URL. Within the XML file, the first element encountered is considered the "table." Child elements of this node are considered the "rows." Child elements of the row nodes are considered "columns." In the absence of a schema, all data is returned as a string type.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |